<%-- 
    Document   : listprovince
    Created on : Apr 9, 2011, 10:37:58 PM
    Author     : Duc Quyen
--%>


<%@page import="java.sql.SQLException"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="Model.ConnectDatabase"%>
<%@page import="java.sql.Connection"%>
<%--<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">



<%
            
            try {
                Statement sta = con.createStatement();
                ResultSet resProvince = sta.executeQuery("select * from province");
                while (resProvince.next()) {
%>
<option value="<%=resProvince.getInt(1)%>"><%=resProvince.getString(2)%></option>
<%              }
                
            } catch (SQLException s) {
                s.printStackTrace();
            }
            %>
